Tabela DrugDBType

Definicja tabeli DrugDBType

Name

DrugDBType

Code

DrugDBType

Comment

Rodzaje baz leków: bazyl, farmindex, leki recepturowe, inne...


Lista kolumn tabeli DrugDBType

Name

Code

DrugDBTypeID

DrugDBTypeID

Active

Active

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

Version

Version

VersionDT

VersionDT

PhVersion

PhVersion

PhVersionDT

PhVersionDT


Kolumna DrugDBTypeID tabeli DrugDBType

Definicja kolumny DrugDBTypeID tabeli DrugDBType

Name

DrugDBTypeID

Code

DrugDBTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli DrugDBType

Definicja kolumny Active tabeli DrugDBType

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna Code tabeli DrugDBType

Definicja kolumny Code tabeli DrugDBType

Name

Code

Code

Code

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

 


Kolumna ShortName tabeli DrugDBType

Definicja kolumny ShortName tabeli DrugDBType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli DrugDBType

Definicja kolumny FullName tabeli DrugDBType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli DrugDBType

Definicja kolumny Description tabeli DrugDBType

Name

Description

Code

Description

Data Type

VARCHAR2(500)

Mandatory

No

Comment

 


Kolumna Version tabeli DrugDBType

Definicja kolumny Version tabeli DrugDBType

Name

Version

Code

Version

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna VersionDT tabeli DrugDBType

Definicja kolumny VersionDT tabeli DrugDBType

Name

VersionDT

Code

VersionDT

Data Type

DATE

Mandatory

No

Comment

Przechowuje date wydania zaimportowanej bazy leków.


Kolumna PhVersion tabeli DrugDBType

Definicja kolumny PhVersion tabeli DrugDBType

Name

PhVersion

Code

PhVersion

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna PhVersionDT tabeli DrugDBType

Definicja kolumny PhVersionDT tabeli DrugDBType

Name

PhVersionDT

Code

PhVersionDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli DrugDBType

Name

Code

Primary

PK_DrugDBType

PK_DrugDBType

X


Klucz PK_DrugDBType tabeli DrugDBType

Definicja klucza PK_DrugDBType tabeli DrugDBType

Name

PK_DrugDBType

Code

PK_DrugDBType

Primary

Yes

Comment